import { DbColumn } from './dbColumn'
import { DbForeignKey } from './dbForeignKey'
import { DbIndex } from './dbIndex'
import { DbPrimaryKey } from './dbPrimaryKey'

/**
 * Describe a table
 */
export interface DbTableMarkdown {
	/**
	 * The table columns
	 */
	columns: DbColumn[]

	/**
	 * The table foreign keys
	 */
	foreignKeys: DbForeignKey[]

	/**
	 * The table indexes
	 */
	indexes: DbIndex[]

	/**
	 * The table primary key
	 */
	primaryKey?: DbPrimaryKey[]

	/**
	 * The table header
	 */
	table: {
		characterSet?: string
		collation?: string
		comment?: string
		engine?: string
		name: string
	}[]
}
